-- DBTools Manager Professional (Enterprise Edition)
-- Database Dump for: xpresso_data
-- Backup Generated in: 6/7/2007 4:54:01 PM
-- Database Server Version: MySQL 4.1.21

-- USEGO

SET FOREIGN_KEY_CHECKS=0;
-- GO


--
-- Dumping Tables
--

--
-- Table: al_activity_log
--
CREATE TABLE `al_activity_log` 
(
	`IdActivity` integer (11) NOT NULL AUTO_INCREMENT , 
	`IdUser` varchar (100) NOT NULL, 
	`UserName` varchar (100) NOT NULL, 
	`ActivityDate` timestamp NOT NULL, 
	`ActivityDescription` varchar (100) NOT NULL,
	PRIMARY KEY (`IdActivity`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: al_activity_log
--
BEGIN;
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(1, '', '', '2006-02-25 16:05:07', 'fdsfg');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(2, '', '', '2006-02-25 16:05:12', 'fdsfg');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(3, '', '', '2006-02-25 16:14:01', 'enrque');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(4, '', '', '2006-02-25 17:28:25', 'enrque');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(5, '', '', '2006-02-25 17:28:40', 'enrque');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(6, '', '', '2006-02-25 17:41:33', 'bldk');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(7, '', '', '2006-02-25 17:42:19', 'enrique');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(8, '', '', '2006-02-25 18:25:58', 'Test');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(9, '', 'Test', '2006-02-25 20:19:03', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(10, '', 'Test', '2006-02-25 20:20:47', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(11, '', 'Test', '2006-02-25 20:25:54', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(12, '', 'Test', '2006-02-25 20:27:10', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(13, '', 'Test', '2006-02-25 20:31:26', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(14, '', 'Test', '2006-02-25 20:32:00', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(15, '', 'Test', '2006-02-25 20:33:37', '');
-- GO
INSERT INTO `al_activity_log` (`IdActivity`, `IdUser`, `UserName`, `ActivityDate`, `ActivityDescription`) VALUES(16, '', 'Test', '2006-02-25 20:36:59', '');
-- GO
COMMIT;
-- GO

--
-- Table: emq_email_queue
--
CREATE TABLE `emq_email_queue` 
(
	`IdEmailQueue` integer (11) NOT NULL AUTO_INCREMENT , 
	`FromName` varchar (255) NOT NULL, 
	`ToName` varchar (255) NOT NULL, 
	`FromEmail` varchar (255) NOT NULL, 
	`ToEmail` varchar (255) NOT NULL, 
	`Subject` varchar (255) NOT NULL, 
	`Body` text NOT NULL, 
	`Sent` char (1) NOT NULL, 
	`Comments` text NOT NULL, 
	`SentDate` datetime NOT NULL, 
	`CreationDate` datetime NOT NULL,
	PRIMARY KEY (`IdEmailQueue`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: emq_email_queue
--
BEGIN;
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(9, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'N', '', '0000-00-00 00:00:00', '2007-04-17 14:26:12');
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(6, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'Y', 'There was a problem sending this email: Error sending email.javax.mail.MessagingException: Could not connect to SMTP host: mail.erclab.com, port: 25;\n  nested exception is:\n	java.net.ConnectException: Connection timed out: connect. Message: null', '2007-04-18 14:23:27', '2007-04-17 14:24:52');
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(7, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'Y', 'Email sent succesfully', '2007-04-17 14:25:50', '2007-04-17 14:25:00');
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(8, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'N', '', '0000-00-00 00:00:00', '2007-04-17 14:25:43');
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(5, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'Y', 'Email sent succesfully', '2007-04-17 14:25:02', '2007-04-17 14:24:23');
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(10, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'N', '', '0000-00-00 00:00:00', '2007-04-17 14:26:21');
-- GO
INSERT INTO `emq_email_queue` (`IdEmailQueue`, `FromName`, `ToName`, `FromEmail`, `ToEmail`, `Subject`, `Body`, `Sent`, `Comments`, `SentDate`, `CreationDate`) VALUES(11, 'Enrique', 'Enrique VW;Enrique Gedas;', 'echamussy@yahoo.com', 'enrique.rodriguez@vw.com; enrique.rodriguez@gedas.com;', 'The subject', 'The body', 'N', '', '0000-00-00 00:00:00', '2007-04-18 14:23:05');
-- GO
COMMIT;
-- GO

--
-- Table: tes_tests
--
CREATE TABLE `tes_tests` 
(
	`IdTestEntry` integer (11) NOT NULL AUTO_INCREMENT , 
	`Column1` varchar (100), 
	`Column2` varchar (100), 
	`Column3` varchar (100), 
	`Column4` varchar (100), 
	`ColumnDate` datetime NOT NULL, 
	`column5` geometry,
	PRIMARY KEY (`IdTestEntry`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: tes_tests
--
BEGIN;
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(1, '.thumb.jpg', '3', '', '', '0000-00-00 00:00:00', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(2, '.thumb.jpg', '5', '', '', '0000-00-00 00:00:00', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(4, '../UserFiles/0/EyeDot.swf', '3', '../UserFiles/0/Game.swf', 'texto', '0000-00-00 00:00:00', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(5, '', '', '', '', '0000-00-00 00:00:00', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(6, '', '', '', '', '2007-03-12 22:39:05', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(7, '../UserFiles/0/DSC01929(5).JPG.thumb.jpg', '', '.thumb.jpg', '', '2007-03-13 16:00:42', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(8, '../UserFiles/0/DSC01929.JPG.thumb.jpg', '', '.thumb.jpg', '', '2007-03-13 16:05:08', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(9, '../UserFiles/0/DSC01929(2).JPG.thumb.jpg', '', '', '', '2007-03-13 16:13:26', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(10, '../UserFiles/0/DSC01929(3).JPG.thumb.jpg', '', '', '', '2007-03-13 16:16:29', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(11, '../UserFiles/0/DSC01929(4).JPG.thumb.jpg', '', '', '', '2007-03-13 16:18:19', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(12, '../UserFiles/0/DSC01929.JPG.thumb.jpg', '', '', '', '2007-03-13 16:19:16', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(13, '../UserFiles/0/DSC01929(1).JPG.thumb.jpg.thumb.jpg', '', '../UserFiles/0/DSC01932.JPG.thumb.jpg', '', '0000-00-00 00:00:00', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(14, '../UserFiles/0/DSC01930.JPG.thumb.jpg', '', '../UserFiles/0/DSC01934.JPG.thumb.jpg', '', '2007-03-13 16:31:32', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(15, '../UserFiles/0/DSC01962.JPG.thumb.jpg', '', '../UserFiles/0/DSC01974.JPG.thumb.jpg', '', '0000-00-00 00:00:00', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(16, '../UserFiles/0/DSC01971.JPG.thumb.jpg', '', '', '', '2007-03-13 16:38:04', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(17, 'Xalapa', '', '', '', '0000-00-00 00:00:00', '');
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(18, '', '', '', '', '2007-03-26 16:31:44', NULL);
-- GO
INSERT INTO `tes_tests` (`IdTestEntry`, `Column1`, `Column2`, `Column3`, `Column4`, `ColumnDate`, `column5`) VALUES(19, '', '', '', '706730.731335802 \r\r\n2160583.531696098', '2007-03-26 16:32:45', NULL);
-- GO
COMMIT;
-- GO

--
-- Table: tes_tests_2
--
CREATE TABLE `tes_tests_2` 
(
	`IdTest` integer (11) NOT NULL AUTO_INCREMENT , 
	`Column1` varchar (100) NOT NULL, 
	`Column2` varchar (100) NOT NULL, 
	`Column3` varchar (100) NOT NULL, 
	`Column4` varchar (100) NOT NULL, 
	`Column5` varchar (100) NOT NULL,
	PRIMARY KEY (`IdTest`)
) TYPE=MyISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- GO

--
-- Dumping Table Data: tes_tests_2
--
BEGIN;
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(1, '49.17721484130587 -0.35430908203125', 'Caen France', 'sdklsfjl', 'kljkl;j', 'kljl');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(2, '-31.39877705996207 -64.18212890625', 'Cordoba argentina', 'sdfs', 'sdfsdf', 'sdfsd');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(3, '18.507610073887584 -88.29299926757812', 'Chetumal Mexico', 'sadfsad', 'sddfasd', 'sdfasdf');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(4, '', 'sdfdf', '', 'asdfa', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(5, '', 'ssad', '', 'safdfas', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(6, '', 'ssad', '', 'asdfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(7, '', 'asdfa', '', 'sadfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(8, '', 'sdafsadf', '', 'sdafasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(9, '', 'sdfsd', '', 'asdfasd', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(10, '', 'sdfasd', '', 'sdfsadfasdfasdfas', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(11, '', 'sdfasdf', '', 'asdfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(12, '', 'asdfas', '', 'asdfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(13, '', 'sdfasdfdfasdf', '', 'dasdfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(14, '', 'asdfas', '', 'sdfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(15, '', '3243234', '', '234234', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(16, '', '36364', '', '564564564', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(17, '', 'asdfasdfsdf', '', 'asdfasdfas', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(18, '', '4577676556', '', '7567576567', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(19, '', '4577676556', '', '54645', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(20, '', 'asdfasdfsdfsad', '', '1', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(21, '', '45675675', '', '222', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(22, '', '775678', '', '7656786', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(23, '', '8999', '', '87657345623', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(24, '', '343535', '', '3456546', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(25, '', '451', '', '513513', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(26, '', '45236623454', '', '53456345634', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(27, '', 'sadfasd', '', 'sdfasdf', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(28, '', '5', '', '5', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(29, '', '4363456', '', '3456345634', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(30, '', '4363456', '', '8756786', 'uno');
-- GO
INSERT INTO `tes_tests_2` (`IdTest`, `Column1`, `Column2`, `Column3`, `Column4`, `Column5`) VALUES(31, '', '44', '', '44', 'uno');
-- GO
COMMIT;
-- GO

--
-- Dumping Tables Foreign Keys
--
SET FOREIGN_KEY_CHECKS=1;
-- GO

